package com.daiyang.mymybatis.mapper;

import com.daiyang.mymybatis.pojo.Department;
import com.daiyang.mymybatis.pojo.Employee;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface EmployeeMapper {

    /**
     * @Author: zhangchunsheng
     * @Date: 2024/11/23 9:10
     * 查询员工信息及员工所属部门信息(部门id部门名称)
     */
    List<Employee> selectAllEmpAndDept();

    Department selectDeptAndEmpByDeptId(Integer deptId);

    Employee selectEmpAndDeptByeIdStep(Integer eId);

    Employee selectEmployeeByeId(Integer dId);

    List<Employee> selectEmpByDynamicCondition(Employee employee);

    List<Employee> selectEmpByChoose(Employee employee);


}